<html>
<head>
<link rel="image_src" href="http://www.coderanch.com/templates/default/images/moosefly.gif" />
<meta property="og:image" content="http://www.coderanch.com/templates/default/images/moosefly.gif"/>
<meta property="og:url" content="http://www.coderanch.com/t/521389/java/java/Parse-SQL-Query-java"/>
<meta property="og:title" content="Parse SQL Query using java (Java in General forum at JavaRanch)"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Expires" content="-1" />
        <link rel="alternate" type="application/rss+xml" title="JavaRanch: Parse SQL Query using java" href="/forums/rss/topicPosts/521389" />
    <meta name="description" content="Hi     user create some sql query. In query contains selected coloumns,and aggregate functions etc. I need to separate selected coloumn using java.   " />
        <meta name="keywords" content="query,aggregate,contains,select,solution,string,stringtokenizer,tokenize" />

<style type="text/css">@import url( /templates/default/styles/style.css?1337072116278 );</style>
<style type="text/css">@import url( /templates/default/styles/en_US.css?1337072116278 );</style>


<title>Parse SQL Query using java (Java in General forum at JavaRanch)</title>

    <link rel="canonical" href="http://www.coderanch.com/t/521389/java/java/Parse-SQL-Query-java" />
    <link rel="alternate" media="handheld" href="http://www.coderanch.com/mobile/t/521389/java/java/Parse-SQL-Query-java?foo=a" />
<link rel="search" type="application/opensearchdescription+xml" href="http://www.coderanch.com/how-to/javaranch-saloon-os.xml" title="JavaRanch Saloon" />
<link rel="search" type="application/opensearchdescription+xml" href="http://www.coderanch.com/how-to/javaranch-faq-os.xml" title="JavaRanch FAQ" />
</head>

<body class="en_US">

    <div align="center" class="shngl">
        <a href="/forums/banner/redirect/312" target="_blank"><img src="http://www.coderanch.com/intellij.png"  border="0" alt="IntelliJ Java IDE"  /></a>
    </div>

<table width="100%" border="0">
    <tr>
        <td>
            <table cellspacing="0" cellpadding="0" width="100%" border="0">
                <tr>
                    <td align="center">

                            <img src="http://www.coderanch.com/mooseImages/moosefly.gif"  vspace="1" border="0" alt="The moose likes Java in General and the fly likes Parse SQL Query using java" title="" />
                    </td>
                    <td class="logo" valign="middle">
                        A friendly place for programming greenhorns!
                    </td>

                    <td width="100%" align="center" valign="middle">
                        <span class="boardtitle">Big Moose Saloon</span>
                        <table cellspacing="0" cellpadding="2" border="0">
                            <tr>
                                <td valign="top" nowrap="nowrap" align="center">&nbsp;
                                    <a id="search" class="mainmenu" href="/forums/search/filters/1"><b>Search</b></a>
                                    | <a id="faq" class="mainmenu nonForumLink" href="http://www.coderanch.com/how-to/java/Java-FAQ"><b>Java FAQ</b></a>
                                    | <a id="latest" class="mainmenu" href="/forums/recentTopics/list">Recent Topics</a>

                                    <br />



                                        <a id="login" class="mainmenu" href="/forums/user/login">Register / Login</a>
                                        <br />

                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        <br /><br />
                                        <div class="announcementBar">Win a copy of <a href="http://www.amazon.com/gp/product/007179431X?tag=jranch-20">Web Developer's Cookbook</a> this week in the <a href="http://www.coderanch.com/forums/f-105/PHP">PHP</a> forum!
</div>
                                    </td>
                                </tr>
                        </table>
                    </td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td>


<script type="text/javascript" src="/templates/default/js/userLocalTime.js?1337072116278"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.2.3/jquery.min.js"></script>
<script type="text/javascript" src="/templates/default/js/jquery.jeditable.pack.js?1337072116278"></script>
<script type="text/javascript" src="/templates/default/js/post_show.js?1337072116278"></script>
<script type="text/javascript" src="/templates/default/js/post.js?1337072116278"></script>
<script type="text/javascript" src="/templates/default/js/pagination.js?1337072116278"></script>
<script type="text/javascript" src="/templates/default/js/wz_tooltip.js"></script>
<script type="text/javascript" src="/templates/default/js/social.js"></script>


<script type="text/javascript">
function showEmail(beforeAt, afterAt)
{
	return beforeAt + "@" + afterAt;
}

function addBookmark(relationType, relationId)
{
	var w = window.open('/forums/bookmarks/insert/' + relationType + '/' + relationId + '', 'bookmark_add', 'width=700, height=200, scrollbars=auto, resizable=true');
	w.focus();
}


    function reportToModerationPrompt(postId) {
        var reason = prompt("Reason for reporting this post:");

        if (reason == null || reason == "") {
            alert("Please specify a reason for reporting this post");
            return false;
        } else {
            var link = document.getElementById("report" + postId);
            link.href += "&reason=" + encodeURIComponent(reason);
        }

        return true;
    }

    var watchImage = "/templates/default/images/watch_topic_start.gif";
    var unwatchImage = "/templates/default/images/stop_watching.gif";
    var watchURL = "/forums/posts/watch/0/521389";
    var unwatchURL = "/forums/posts/unwatch/0/521389";
    var unwatchHandler = function() { turnOn=false; toggleWatch(); return false; };
    var watchHandler = function() { turnOn=true; toggleWatch(); return false; };
    var turnOn, remove;

    function toggleWatch () {
        $.ajax({
            url: turnOn ? watchURL : unwatchURL,
            type: 'POST',
            dataType: 'json',
            success: function (data) {
                //$("#messages").html(data.message);
                if (turnOn) {
                    $(".toggleWatchImage")[0].src = unwatchImage;
                    $(".toggleWatchImage")[1].src = unwatchImage;
                    $(".toggleWatchLink")[0].href = unwatchURL;
                    $(".toggleWatchLink")[1].href = unwatchURL;
                    $(".toggleWatchLink")[0].onclick = unwatchHandler;
                    $(".toggleWatchLink")[1].onclick = unwatchHandler;
                } else {
                    if (remove) {
                        // for unwatching locked topics
                        $(".toggleWatchImage")[0].style.visibility = "hidden";
                        $(".toggleWatchImage")[1].style.visibility = "hidden";
                        $(".toggleWatchLink")[0].href = "#";
                        $(".toggleWatchLink")[1].href = "#";
                        $(".toggleWatchLink")[0].onclick = "return false;";
                        $(".toggleWatchLink")[1].onclick = "return false;";
                    } else {
                        $(".toggleWatchImage")[0].src = watchImage;
                        $(".toggleWatchImage")[1].src = watchImage;
                        $(".toggleWatchLink")[0].href = watchURL;
                        $(".toggleWatchLink")[1].href = watchURL;
                        $(".toggleWatchLink")[0].onclick = watchHandler;
                        $(".toggleWatchLink")[1].onclick = watchHandler;
                    }
                }
            }
        });
    }

    var likeImage = "/templates/default/images/jr.button.plus.1.thumb.gif";
    var unlikeImage = "/templates/default/images/jr.button.minus.1.thumb.gif";

    function toggleLike (postId) {
        var likeURL = "/forums/posts/like/" + postId + "";
        var unlikeURL = "/forums/posts/unlike/" + postId + "";

        var unlikeHandler = function() { turnOn=false; toggleLike(postId); return false; };
        var likeHandler = function() { turnOn=true; toggleLike(postId); return false; };

        $.ajax({
            url: turnOn ? likeURL : unlikeURL,
            type: 'POST',
            dataType: 'json',
            success: function (data) {
                $("#like_message_" + postId).html("<img src='/templates/default/images/thumbs-up.gif'"
                                                    +" title='"+data.message+"'/> "+data.count);
                if (turnOn) {
                    $(".toggleLikeImage_"+postId)[0].src = unlikeImage;
                    $(".toggleLikeLink_"+postId)[0].href = unlikeURL;
                    $(".toggleLikeLink_"+postId)[0].onclick = unlikeHandler;
                    $("#like_message_" + postId).css("visibility", "visible");
                } else {
                    $(".toggleLikeImage_"+postId)[0].src = likeImage;
                    $(".toggleLikeLink_"+postId)[0].href = likeURL;
                    $(".toggleLikeLink_"+postId)[0].onclick = likeHandler;
                    if (data.count == 0)
                        $("#like_message_" + postId).css("visibility", "hidden");
                }
            }
        });
    }

</script>



<table cellspacing="0" cellpadding="10" width="97%" align="center" border="0">
    <tr>
        <td class="bodyline">
        <span class="nav">
            <a class="maintitle" href="http://www.javaranch.com/">JavaRanch</a> &raquo; <a class="maintitle" href="http://www.coderanch.com/forums">Java Forums</a> &raquo;
            <a class="maintitle" href="/forums/c/1/java">Java</a> &raquo;
            <a class="maintitle" href="/forums/f-1/java">Java in General</a>
        </span>



            
<table cellspacing="2" cellpadding="2" width="100%" border="0" class="threadbar">
  <tr>
    <td align="left" valign="middle">
    			<img class="opaque" title="You must login or register" alt="Reply" src="/templates/default/images/reply.gif" width="82px" height="25px" />
			<img class="opaque" title="You must login or register" src="/templates/default/images/bookmark_it.gif" alt='Bookmark "Parse SQL Query using java"' width="82" height="25" />
		<img class="opaque" title="You must login or register" 
		  	src="/templates/default/images/watch_topic_start.gif"
			alt='Watch "Parse SQL Query using java"' width="82" height="25" />
    </td>
    <td align="right">
      	<img class="opaque" title="You must login or register" alt="New topic" src="/templates/default/images/post.gif" width="82px" height="25px" />
    </td>    
  </tr>
</table>
            <table id="postTable" class="forumline" cellspacing="0" cellpadding="0" width="100%" border="0">
                                <a name="2361597">
                </a><tr>
                    <th class="author" nowrap="nowrap" width="18%">Author</th>
                    <th class="subject">
                        <h1>
                            <span id="topicSubject">Parse SQL Query using java</span>
                        </h1>
                    </th>
                </tr>
                                </a>





                    <tr class="firstRowOfPost">



                        <td class="row1 userPostInfo" valign="top" align="left" rowspan="2">
                            <a name="2361597"></a>
<span class="authorNameNoLink" title="You must login or register">mani nataraj</span>


<br />

<span class="gensmall">
	Greenhorn
	<br />

<br />


	Joined: Dec 20, 2010<br />
	Posts: 12
<br />


</span>

                        </td>

                        <td colspan="1" class="row1" valign="top">
<div class="postinfo row1">
	<div class="date">
		<span class="postdetails">posted <script>"Dec 23, 2010 13:13:43".toLocaleDateTime();</script><noscript><span class="lastPostTime">Dec 23, 2010 06:13:43</span></noscript></span>                

		<img class="opaque" alt="private message" title="You must login or register" src="/templates/default/images/icon_pm.gif" width="59px" height="18px" />


    </div>
	<div class="action">
			<div id="like_message_2361597"
					class="likesHiddenDiv"
			>
				<img src="/templates/default/images/thumbs-up.gif"
				/>
				0        
			</div>
			<img class="opaque" alt="Quote" title="You must login or register" src="/templates/default/images/icon_quote.gif" width="59" height="18px" />
	</div>
</div>
                        </td>
                    </tr>

                    <tr class="messageRow">

                        <td class="row1 postbody" valign="top" id="post_text_2361597">
                            <span class="postbody">
                                    Hi <br /> <br />    user create some sql query. In query contains selected coloumns,and aggregate functions etc. I need to separate selected coloumn using <a href="http://www.javaranch.com" class="faq" title="JavaRanch" target="_new">java</a>.<br />    <br />    For Ex: SELECT EMP_NAME,EMP_NO,EMP_ADDRESS,EMP_RELION,EMP_PINCODE,EMP_MOBILE,<br />                DECODE(EMP_NAME,'<a href="http://www.javaranch.com/unit-testing.jsp" class="api" title="article: Evil Unit Testing" target="_new">TEST</a>', EMP_NAME,EMP_NAME)  from   EMP;<br /> <br />    I am trying to parse query using <a href="http://docs.oracle.com/javase/7/docs/api/java/util/StringTokenizer.html" class="api" title="Java API" target="_new">StringTokenizer</a> using "," separator but not parse in properly<br />    <br />    How to do this. Can you give me a solution for this.
                            </span>


                        </td>
                    </tr>

                    <tr>
                        <td class="spacerow row1" colspan="2" height="1"><img src="/templates/default/images/spacer.gif" alt="" width="1" height="1" /></td>
                    </tr>




                    <tr class="firstRowOfPost">



                        <td class="row2 userPostInfo" valign="top" align="left" rowspan="3">
                            <a name="2361611"></a>
<span class="authorNameNoLink" title="You must login or register">Rob Spoor</span>


<br />

<span class="gensmall">
	Saloon Keeper
	<br />

<br />


	Joined: Oct 27, 2005<br />
	Posts: 18260
<br />


</span>
<br />
<div class="bumperStickers">
    <a class="nonForumLink" href="http://www.coderanch.com/how-to/java/BumperStickers" target="_blank">I like...</a><br />
     	<img src="/images/bumperStickers/16_android.gif" alt="Android" title="Android" border="0" />
     	<img src="/images/bumperStickers/16_eclipse.gif" alt="Eclipse IDE" title="Eclipse IDE" border="0" />
     	<img src="/images/bumperStickers/16_opera.gif" alt="Opera" title="Opera" border="0" />
</div>

                        </td>

                        <td colspan="1" class="row2" valign="top">
<div class="postinfo row2">
	<div class="date">
		<span class="postdetails">posted <script>"Dec 23, 2010 13:47:53".toLocaleDateTime();</script><noscript><span class="lastPostTime">Dec 23, 2010 06:47:53</span></noscript></span>                

		<img class="opaque" alt="private message" title="You must login or register" src="/templates/default/images/icon_pm.gif" width="59px" height="18px" />


    </div>
	<div class="action">
			<div id="like_message_2361611"
					class="likesHiddenDiv"
			>
				<img src="/templates/default/images/thumbs-up.gif"
				/>
				0        
			</div>
			<img class="opaque" alt="Quote" title="You must login or register" src="/templates/default/images/icon_quote.gif" width="59" height="18px" />
	</div>
</div>
                        </td>
                    </tr>

                    <tr class="messageRow">

                        <td class="row2 postbody" valign="top" id="post_text_2361611">
                            <span class="postbody">
                                    ZQL is an SQL parser for Java.
                            </span>


                        </td>
                    </tr>

                        <tr>
                            <td colspan="2" class="row2" width="100%" height="28">
                            <br />
                                <hr/>
                                <span class="userSignature">SCJP 1.4 - SCJP 6 - SCWCD 5<br /><a class="snap_shots" href="http://faq.javaranch.com/java/HowToAskQuestionsOnJavaRanch" target="_new" >How To Ask Questions</a> <a class="snap_shots" href="http://faq.javaranch.com/java/HowToAnswerQuestionsOnJavaRanch" target="_new" >How To Answer Questions</a></span>
                            </td>
                        </tr>
                    <tr>
                        <td class="spacerow row2" colspan="2" height="1"><img src="/templates/default/images/spacer.gif" alt="" width="1" height="1" /></td>
                    </tr>




                    <tr class="firstRowOfPost">



                        <td class="row1 userPostInfo" valign="top" align="left" rowspan="3">
                            <a name="2361614"></a>
<span class="authorNameNoLink" title="You must login or register">fred rosenberger</span>


<br />

<span class="gensmall">
	lowercase baba
	<br />
	Bartender
	<br />

<br />


	Joined: Oct 02, 2003<br />
	Posts: 8388
<br />


</span>
  <iframe src="/forums/bbf/belt/frozenfred" frameBorder="0" height=30 width=40 scrolling="no"></iframe>
<br />
<div class="bumperStickers">
    <a class="nonForumLink" href="http://www.coderanch.com/how-to/java/BumperStickers" target="_blank">I like...</a><br />
     	<img src="/images/bumperStickers/16_firefox.gif" alt="Firefox Browser" title="Firefox Browser" border="0" />
     	<img src="/images/bumperStickers/16_java.gif" alt="Java" title="Java" border="0" />
     	<img src="/images/bumperStickers/16_linux.gif" alt="Linux" title="Linux" border="0" />
</div>

                        </td>

                        <td colspan="1" class="row1" valign="top">
<div class="postinfo row1">
	<div class="date">
		<span class="postdetails">posted <script>"Dec 23, 2010 13:50:16".toLocaleDateTime();</script><noscript><span class="lastPostTime">Dec 23, 2010 06:50:16</span></noscript></span>                

		<img class="opaque" alt="private message" title="You must login or register" src="/templates/default/images/icon_pm.gif" width="59px" height="18px" />


    </div>
	<div class="action">
			<div id="like_message_2361614"
					class="likesHiddenDiv"
			>
				<img src="/templates/default/images/thumbs-up.gif"
				/>
				0        
			</div>
			<img class="opaque" alt="Quote" title="You must login or register" src="/templates/default/images/icon_quote.gif" width="59" height="18px" />
	</div>
</div>
                        </td>
                    </tr>

                    <tr class="messageRow">

                        <td class="row1 postbody" valign="top" id="post_text_2361614">
                            <span class="postbody">
                                    I think you need to break it apart a piece at a time.  First, break apart the <a href="http://www.coderanch.com/t/410859/java/java/String-StringBuffer-StringBuilder-Performance" class="api" title="String vs. StringBuilder/StringBuffer" target="_new">string</a> bases on the SQL keywords (like "select", "from", "where" "group by", "sort by", etc).  Once you have everything that is between "select" and "from", you should be able to pick that apart by the commas.
                            </span>


                        </td>
                    </tr>

                        <tr>
                            <td colspan="2" class="row1" width="100%" height="28">
                            <br />
                                <hr/>
                                <span class="userSignature">Never ascribe to malice that which can be adequately explained by stupidity.<br /></span>
                            </td>
                        </tr>
                    <tr>
                        <td class="spacerow row1" colspan="2" height="1"><img src="/templates/default/images/spacer.gif" alt="" width="1" height="1" /></td>
                    </tr>




                    <tr class="firstRowOfPost">



                        <td class="row2 userPostInfo" valign="top" align="left" rowspan="3">
                            <a name="2361620"></a>
<span class="authorNameNoLink" title="You must login or register">Ulf Dittmer</span>


<br />

<span class="gensmall">
	Marshal
	<br />

<br />


	Joined: Mar 22, 2005<br />
	Posts: 32756
<br />


</span>
  <iframe src="/forums/bbf/belt/udittmer" frameBorder="0" height=30 width=40 scrolling="no"></iframe>

                        </td>

                        <td colspan="1" class="row2" valign="top">
<div class="postinfo row2">
	<div class="date">
		<span class="postdetails">posted <script>"Dec 23, 2010 14:02:14".toLocaleDateTime();</script><noscript><span class="lastPostTime">Dec 23, 2010 07:02:14</span></noscript></span>                



    </div>
	<div class="action">
			<div id="like_message_2361620"
					class="likesDiv"
			>
				<img src="/templates/default/images/thumbs-up.gif"
						title='1 person found this post helpful.'
				/>
				1        
			</div>
			<img class="opaque" alt="Quote" title="You must login or register" src="/templates/default/images/icon_quote.gif" width="59" height="18px" />
	</div>
</div>
                        </td>
                    </tr>

                    <tr class="messageRow">

                        <td class="row2 postbody" valign="top" id="post_text_2361620">
                            <span class="postbody">
                                    I bet at least one of the standard Java parser packages (Antlr, JavaCC, SableCC) comes with a predefined grammar for SQL.
                            </span>


                        </td>
                    </tr>

                        <tr>
                            <td colspan="2" class="row2" width="100%" height="28">
                            <br />
                                <hr/>
                                <span class="userSignature"><a class="snap_shots" href="http://www.ulfdittmer.com/android/" target="_new" >Android apps</a> – <a class="snap_shots" href="http://www.ulfdittmer.com/imagej/" target="_new" >ImageJ plugins</a> – <a class="snap_shots" href="http://cewolf.sourceforge.net/new/" target="_new" >Java web charts</a></span>
                            </td>
                        </tr>
                    <tr>
                        <td class="spacerow row2" colspan="2" height="1"><img src="/templates/default/images/spacer.gif" alt="" width="1" height="1" /></td>
                    </tr>
            <tr>
            <td width="18%" bgcolor="#DEC7A4"><img src="/images/bunkhouse_smoke.gif"/></td>
            <td width="82%" align="left" valign="top"  bgcolor="#DEC7A4">
                &nbsp;<BR>
                    <div align="left" class="shngl">
                        <script type="text/javascript"><!--
google_ad_client = "pub-4768842087373098";
/* crf/s1/ss */
google_ad_slot = "3954018497";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

                    </div>
                &nbsp;<BR>
                </td>
                </tr>
                <tr class="postbody" align="left">
                    <td colspan="2">
                    subject: Parse SQL Query using java
                    </td>
                </tr>

                <tr align="center">
                    <td class="catbottom" colspan="2" height="28">
                        <table cellspacing="0" cellpadding="0" border="0">
                            <tr>
                                <td align="center"><span class="gensmall">&nbsp;</span></td>
                            </tr>
                        </table>
                    </td>
                </tr>
            </table>
             
            
            <table width="100%" align="center">


            </table>

        </td>
    </tr>
</table>

<table class="highlights" align="center">
<tr><th colspan="2">Threads others viewed</th></tr>
<tr>
  <tr><td class="row1 gen"><a href="/t/304547/JDBC/java/Resultset-million-rows"> 
  Resultset with million rows</a></td></tr>
  <tr><td class="row1 gen"><a href="/t/500360/JDBC/java/apply-query-after-concate-two"> 
  apply query after concate two column</a></td></tr>
  <tr><td class="row1 gen"><a href="/t/389810/java/java/dynamic-help"> 
  dynamic help</a></td></tr>
  <tr><td class="row1 gen"><a href="/t/415282/ORM/java/Named-Query"> 
  Named Query...</a></td></tr>
  <tr><td class="row1 gen"><a href="/t/217480/ORM/java/Hibernate-Query-condition"> 
  Hibernate Query with AND condition</a></td></tr>
</tr>
</table>

<a name="quick"></a>

<script type="text/javascript">
$(document).ready(function() {
    limitURLSize();
});
</script>

		</td>
	</tr>
</table>
<div class="gensmall center">
<script>
document.write("All times above are in your local time zone & format.");
document.write("The current ranch time (not your local time) is ");
document.write("May 15, 2012 10:35:13".bold() + ".");
</script><noscript>All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter</noscript>
</div>

	<div align="center" class="shngl">
		<a href="/forums/banner/redirect/313" target="_blank"><img src="http://www.coderanch.com/intellij.png"  border="0" alt="IntelliJ Java IDE"  /></a>
	</div>

<script type="text/javascript">
	var gaJsHost = (("https:" == document.location.protocol) ?  "https://ssl." : "http://www.");
	document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
if (typeof _gat !== "undefined") {
	var pageTracker = _gat._getTracker("UA-2371260-2");
	pageTracker._trackPageview();

	dt = new Date();
	pageTracker._setVar("hour: " + dt.getHours());
}
</script>

<br />
<div class="float-divider"></div>
<div id="footer">
 <div class="footerLinksDiv center">
	<a class="nonForumLink" href="http://www.coderanch.com/how-to/code/ContactUs">Contact Us</a>
	| Powered by <a href="http://www.jforum.net/" target="_blank">JForum</a>
	| <span class="copyrightOwner">Copyright &copy; 1998-2012 <a href="http://www.javaranch.com/paul-wheaton.jsp">Paul Wheaton</a></span>
 </div>
</div>
<div class="float-divider"></div>

<div align="center" class="shngl">
	<div style="margin-left:25px; margin-bottom:25px; width:600px">

<img src="/images/cast-iron-skillet-49er-wide.png" alt="cast iron skillet 49er" title="if you don't behave, this guy will whack you on the head with his cast iron skillet" style="float:left;"/>

<p>
more from paul wheaton's glorious empire of web junk: 
<a href="http://www.richsoil.com/cast-iron.jsp">cast iron skillet</a>
<a href="http://www.richsoil.com/diatomaceous-earth.jsp">diatomaceous earth</a>
<a href="http://www.richsoil.com/rocket-stove-mass-heater.jsp">rocket mass heater</a>
<a href="http://www.richsoil.com/sepp-holzer/sepp-holzer-permaculture.jsp">sepp holzer</a>
<a href="http://www.richsoil.com/hugelkultur/">raised garden beds</a>
<a href="http://www.richsoil.com/raising-chickens.jsp">raising chickens</a>
<a href="http://www.richsoil.com/lawn-care.jsp">lawn care</a>
<a href="http://www.richsoil.com/CFL-fluorescent-light-bulbs.jsp">CFL</a>
<a href="http://www.richsoil.com/flea-control.jsp">flea control</a>
<a href="http://www.permies.com/missoula">missoula</a>
<a href="http://www.richsoil.com/electric-heat.jsp">heat</a>
<a href="http://www.permies.com/permaculture-forums">permaculture</a>
</p>

</div>

</div>

</body>
</html>
